About

Mary Anne Dryja is an experienced Senior Data Warehouse Engineer with over 25 years of experience in the financial services, ecommerce, and healthcare industries. She has a strong background in relational databases such as MSSQL Server, MySQL, Snowflake, BigQuery, and Postgres, as well as experience using integration tools such as SSIS, Matillion, and GCP data fusion. Mary Anne is a skilled business intelligence and analytics professional who loves solving data problems. Mary Anne currently works as a Sr Data Warehouse Engineer at Volusion, where she assists in building and maintaining data warehouse data integrations leveraging both MS SQL Integration services and Python technologies. She also develops and optimizes SQL queries leveraged by existing integration services, reporting processes, and data analysis reports, and develops dashboards and visualizations for ongoing measurement and KPIs. Mary Anne is responsible for planning for non-transactional data storage for reporting and analytics, database schema design, and data flow architecture planning. She maintains current reports in existing reporting platforms and profiles source system data as needed to provide feedback for business requirements. Additionally, Mary Anne analyzes and verifies Data Warehouse data and assists in the design, build, and maintenance of SSAS cubes. Previously, Mary Anne worked at Adometry as a Team Lead for Integration Engineering and an Implementation Engineer. In her role as Team Lead, she coordinated the efforts of 5 team members who collected and integrated customer data into Google's Adometry Ad Analytics software platform. Her primary responsibilities included understanding and thorough documentation of each customer's unique business requirements and technical integration details, loading customer data via Vertica into Big Data systems, accurate and timely data mapping and integration, and successful report generation. Mary Anne also acted as a technical implementation team lead on broad, complex, and critical engagements to configure and integrate Attribute analytics software with big data gathered from online advertising. She wrote custom SQL ETL for each customer to translate the requirements into a solutions strategy for Attribute implementation and reporting. Mary Anne holds a BS degree in Mathematics from Northern Illinois University. Her tech stack includes Data Engineering, Data Warehouse, Snowflake, Integration, MySQL, MSSQL, Postgres, GCP, SQL, and Python.